﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="B2BDataSet" targetNamespace="http://tempuri.org/B2BDataSet.xsd" xmlns:mstns="http://tempuri.org/B2BDataSet.xsd" xmlns="http://tempuri.org/B2BDataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="MySettings" AppSettingsPropertyName="B2BConnectionString" ConnectionStringObject="" IsAppSettingsProperty="True" Modifier="Assembly" Name="B2BConnectionString (MySettings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.BTB.My.MySettings.GlobalReference.Default.B2BConnectionString" Provider="System.Data.SqlClient">
          </Connection>
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="EXT_PATIENTTableAdapter" GeneratorDataComponentClassName="EXT_PATIENTTableAdapter" Name="EXT_PATIENT" UserDataComponentName="EXT_PATIENTTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="B2BConnectionString (MySettings)" DbObjectName="B2B.dbo.EXT_PATIENT" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetData" UserSourceName="Fill">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>INSERT INTO [dbo].[EXT_PATIENT] ([PTNT_PRN], [PRSN_BIRTH_DATE], [PDTL_RACE], [PRSN_SEX], [PRSN_SURNAME], [PDTL_NATIONALITY]) VALUES (@PTNT_PRN, @PRSN_BIRTH_DATE, @PDTL_RACE, @PRSN_SEX, @PRSN_SURNAME, @PDTL_NATIONALITY)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@PTNT_PRN" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="PTNT_PRN" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@PRSN_BIRTH_DATE" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="PRSN_BIRTH_DATE" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@PDTL_RACE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="PDTL_RACE" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@PRSN_SEX" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="PRSN_SEX" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@PRSN_SURNAME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="PRSN_SURNAME" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@PDTL_NATIONALITY" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="PDTL_NATIONALITY" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>SELECT PTNT_PRN, PRSN_BIRTH_DATE, PDTL_RACE, PRSN_SEX, PRSN_SURNAME, PDTL_NATIONALITY FROM dbo.EXT_PATIENT</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="PTNT_PRN" DataSetColumn="PTNT_PRN" />
              <Mapping SourceColumn="PRSN_BIRTH_DATE" DataSetColumn="PRSN_BIRTH_DATE" />
              <Mapping SourceColumn="PDTL_RACE" DataSetColumn="PDTL_RACE" />
              <Mapping SourceColumn="PRSN_SEX" DataSetColumn="PRSN_SEX" />
              <Mapping SourceColumn="PRSN_SURNAME" DataSetColumn="PRSN_SURNAME" />
              <Mapping SourceColumn="PDTL_NATIONALITY" DataSetColumn="PDTL_NATIONALITY" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="NationalityTableAdapter" GeneratorDataComponentClassName="NationalityTableAdapter" Name="Nationality" UserDataComponentName="NationalityTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="B2BConnectionString (MySettings)" DbObjectName="B2B.dbo.Nationality" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetData" UserSourceName="Fill">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>INSERT INTO [dbo].[Nationality] ([Code], [Description]) VALUES (@Code, @Description)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Code" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Code" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Description" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>SELECT Code, Description FROM dbo.Nationality</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Code" DataSetColumn="Code" />
              <Mapping SourceColumn="Description" DataSetColumn="Description" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="PatientTableAdapter" GeneratorDataComponentClassName="PatientTableAdapter" Name="Patient" UserDataComponentName="PatientTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="B2BConnectionString (MySettings)" DbObjectName="B2B.dbo.Patient" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetData" UserSourceName="Fill">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>INSERT INTO [dbo].[Patient] ([Patient_Id], [patient_NM], [DOB], [Gender], [Addr1], [Addr2], [Addr3], [City], [Postal], [Phone], [Fax], [State], [Country], [CellPhone], [Email], [M_Addr1], [M_Addr2], [M_Addr3], [M_City], [M_Postal], [M_Phone], [M_Fax], [M_State], [M_country], [M_CellPhone], [M_Email], [Last_NM], [First_NM], [Middle_NM], [Other_NM], [MRID], [Birth_Place], [Marital_Status_ID], [Language_ID], [Religion_ID], [Age], [Emer_RelationShip], [Emer_Last_NM], [Emer_1stNM], [Emer_Addr1], [Emer_Addr2], [Emer_City], [Emer_Postal], [Emer_Phone], [Emer_Fax], [Emer_State], [Emer_Country], [Emer_CellPhone], [Emer_Email], [Reserved_1], [Reserved_2], [Reserved_3], [Reserved_4], [Reserved_5], [Reserved_6], [Reserved_7], [Reserved_8], [Prim_Physician], [Ref1_Physician], [Ref2_Physician], [Ref1_Addr1], [Ref1_Phone], [Ref1_Fax], [Ref1_Email], [Ref1_Facility], [Ref2_Addr1], [Ref2_Phone], [Ref2_Fax], [Ref2_Email], [Ref2_Facility], [Salutation_ID], [Register_Dt], [W_Addr1], [W_Addr2], [W_City], [W_Postal], [W_Phone], [W_Fax], [W_State], [W_Country], [W_CellPhone], [W_Email], [Al_Addr1], [Al_Addr2], [Al_City], [Al_Postal], [Al_Phone], [Al_Fax], [Al_State], [Al_Country], [AL_CellPhone], [AL_Email], [Create_Dt], [TimeStamps], [Create_UserId], [Edit_UserId], [NRIC], [Status]) VALUES (@Pt_id1, @patient_NM, @DOB, @Gender, @Addr1, @Addr2, @Addr3, @City, @Postal, @Phone, @Fax, @State, @Country, @CellPhone, @Email, @M_Addr1, @M_Addr2, @M_Addr3, @M_City, @M_Postal, @M_Phone, @M_Fax, @M_State, @M_country, @M_CellPhone, @M_Email, @Last_NM, @First_NM, @Middle_NM, @Other_NM, @MRID, @Birth_Place, @Marital_Status_ID, @Language_ID, @Religion_ID, @Age, @Emer_RelationShip, @Emer_Last_NM, @Emer_1stNM, @Emer_Addr1, @Emer_Addr2, @Emer_City, @Emer_Postal, @Emer_Phone, @Emer_Fax, @Emer_State, @Emer_Country, @Emer_CellPhone, @Emer_Email, @Reserved_1, @Reserved_2, @Reserved_3, @Reserved_4, @Reserved_5, @Reserved_6, @Reserved_7, @Reserved_8, @Prim_Physician, @Ref1_Physician, @Ref2_Physician, @Ref1_Addr1, @Ref1_Phone, @Ref1_Fax, @Ref1_Email, @Ref1_Facility, @Ref2_Addr1, @Ref2_Phone, @Ref2_Fax, @Ref2_Email, @Ref2_Facility, @Salutation_ID, @Register_Dt, @W_Addr1, @W_Addr2, @W_City, @W_Postal, @W_Phone, @W_Fax, @W_State, @W_Country, @W_CellPhone, @W_Email, @Al_Addr1, @Al_Addr2, @Al_City, @Al_Postal, @Al_Phone, @Al_Fax, @Al_State, @Al_Country, @AL_CellPhone, @AL_Email, @Create_Dt, @TimeStamps, @Create_UserId, @Edit_UserId, @NRIC, @Status)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Pt_id1" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Patient_Id" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@patient_NM" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="patient_NM" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DOB" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DOB" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Gender" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Gender" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Addr1" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Addr1" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Addr2" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Addr2" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Addr3" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Addr3" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@City" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="City" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Postal" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Postal" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Phone" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Phone" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Fax" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Fax" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@State" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="State" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Country" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Country" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CellPhone" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CellPhone" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Email" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@M_Addr1" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="M_Addr1" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@M_Addr2" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="M_Addr2" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@M_Addr3" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="M_Addr3" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@M_City" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="M_City" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@M_Postal" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="M_Postal" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@M_Phone" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="M_Phone" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@M_Fax" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="M_Fax" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@M_State" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="M_State" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@M_country" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="M_country" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@M_CellPhone" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="M_CellPhone" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@M_Email" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="M_Email" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Last_NM" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Last_NM" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@First_NM" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="First_NM" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Middle_NM" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Middle_NM" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Other_NM" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Other_NM" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@MRID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="MRID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Birth_Place" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Birth_Place" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Marital_Status_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Marital_Status_ID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Language_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Language_ID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Religion_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Religion_ID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Age" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Age" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Emer_RelationShip" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Emer_RelationShip" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Emer_Last_NM" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Emer_Last_NM" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Emer_1stNM" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Emer_1stNM" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Emer_Addr1" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Emer_Addr1" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Emer_Addr2" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Emer_Addr2" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Emer_City" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Emer_City" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Emer_Postal" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Emer_Postal" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Emer_Phone" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Emer_Phone" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Emer_Fax" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Emer_Fax" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Emer_State" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Emer_State" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Emer_Country" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Emer_Country" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Emer_CellPhone" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Emer_CellPhone" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Emer_Email" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Emer_Email" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Reserved_1" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Reserved_1" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Reserved_2" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Reserved_2" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Reserved_3" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Reserved_3" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Reserved_4" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Reserved_4" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Reserved_5" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Reserved_5" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Reserved_6" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Reserved_6" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Reserved_7" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Reserved_7" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Reserved_8" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Reserved_8" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Prim_Physician" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Prim_Physician" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Ref1_Physician" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Ref1_Physician" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Ref2_Physician" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Ref2_Physician" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Ref1_Addr1" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Ref1_Addr1" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Ref1_Phone" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Ref1_Phone" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Ref1_Fax" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Ref1_Fax" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Ref1_Email" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Ref1_Email" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Ref1_Facility" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Ref1_Facility" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Ref2_Addr1" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Ref2_Addr1" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Ref2_Phone" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Ref2_Phone" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Ref2_Fax" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Ref2_Fax" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Ref2_Email" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Ref2_Email" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Ref2_Facility" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Ref2_Facility" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Salutation_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Salutation_ID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Register_Dt" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Register_Dt" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@W_Addr1" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="W_Addr1" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@W_Addr2" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="W_Addr2" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@W_City" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="W_City" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@W_Postal" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="W_Postal" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@W_Phone" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="W_Phone" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@W_Fax" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="W_Fax" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@W_State" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="W_State" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@W_Country" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="W_Country" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@W_CellPhone" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="W_CellPhone" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@W_Email" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="W_Email" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Al_Addr1" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Al_Addr1" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Al_Addr2" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Al_Addr2" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Al_City" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Al_City" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Al_Postal" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Al_Postal" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Al_Phone" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Al_Phone" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Al_Fax" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Al_Fax" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Al_State" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Al_State" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Al_Country" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Al_Country" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@AL_CellPhone" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="AL_CellPhone" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@AL_Email" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="AL_Email" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Create_Dt" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Create_Dt" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@TimeStamps" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="TimeStamps" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Create_UserId" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Create_UserId" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Edit_UserId" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Edit_UserId" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@NRIC" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="NRIC" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Status" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Status" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>SELECT Patient_Id, patient_NM, DOB, Gender, Addr1, Addr2, Addr3, City, Postal, Phone, Fax, State, Country, CellPhone, Email, M_Addr1, M_Addr2, M_Addr3, M_City, M_Postal, M_Phone, M_Fax, M_State, M_country, M_CellPhone, M_Email, Last_NM, First_NM, Middle_NM, Other_NM, MRID, Birth_Place, Marital_Status_ID, Language_ID, Religion_ID, Age, Emer_RelationShip, Emer_Last_NM, Emer_1stNM, Emer_Addr1, Emer_Addr2, Emer_City, Emer_Postal, Emer_Phone, Emer_Fax, Emer_State, Emer_Country, Emer_CellPhone, Emer_Email, Reserved_1, Reserved_2, Reserved_3, Reserved_4, Reserved_5, Reserved_6, Reserved_7, Reserved_8, Prim_Physician, Ref1_Physician, Ref2_Physician, Ref1_Addr1, Ref1_Phone, Ref1_Fax, Ref1_Email, Ref1_Facility, Ref2_Addr1, Ref2_Phone, Ref2_Fax, Ref2_Email, Ref2_Facility, Salutation_ID, Register_Dt, W_Addr1, W_Addr2, W_City, W_Postal, W_Phone, W_Fax, W_State, W_Country, W_CellPhone, W_Email, Al_Addr1, Al_Addr2, Al_City, Al_Postal, Al_Phone, Al_Fax, Al_State, Al_Country, AL_CellPhone, AL_Email, Patient_No, Create_Dt, TimeStamps, Create_UserId, Edit_UserId, NRIC, Status FROM dbo.Patient</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Patient_Id" DataSetColumn="Patient_Id" />
              <Mapping SourceColumn="patient_NM" DataSetColumn="patient_NM" />
              <Mapping SourceColumn="DOB" DataSetColumn="DOB" />
              <Mapping SourceColumn="Gender" DataSetColumn="Gender" />
              <Mapping SourceColumn="Addr1" DataSetColumn="Addr1" />
              <Mapping SourceColumn="Addr2" DataSetColumn="Addr2" />
              <Mapping SourceColumn="Addr3" DataSetColumn="Addr3" />
              <Mapping SourceColumn="City" DataSetColumn="City" />
              <Mapping SourceColumn="Postal" DataSetColumn="Postal" />
              <Mapping SourceColumn="Phone" DataSetColumn="Phone" />
              <Mapping SourceColumn="Fax" DataSetColumn="Fax" />
              <Mapping SourceColumn="State" DataSetColumn="State" />
              <Mapping SourceColumn="Country" DataSetColumn="Country" />
              <Mapping SourceColumn="CellPhone" DataSetColumn="CellPhone" />
              <Mapping SourceColumn="Email" DataSetColumn="Email" />
              <Mapping SourceColumn="M_Addr1" DataSetColumn="M_Addr1" />
              <Mapping SourceColumn="M_Addr2" DataSetColumn="M_Addr2" />
              <Mapping SourceColumn="M_Addr3" DataSetColumn="M_Addr3" />
              <Mapping SourceColumn="M_City" DataSetColumn="M_City" />
              <Mapping SourceColumn="M_Postal" DataSetColumn="M_Postal" />
              <Mapping SourceColumn="M_Phone" DataSetColumn="M_Phone" />
              <Mapping SourceColumn="M_Fax" DataSetColumn="M_Fax" />
              <Mapping SourceColumn="M_State" DataSetColumn="M_State" />
              <Mapping SourceColumn="M_country" DataSetColumn="M_country" />
              <Mapping SourceColumn="M_CellPhone" DataSetColumn="M_CellPhone" />
              <Mapping SourceColumn="M_Email" DataSetColumn="M_Email" />
              <Mapping SourceColumn="Last_NM" DataSetColumn="Last_NM" />
              <Mapping SourceColumn="First_NM" DataSetColumn="First_NM" />
              <Mapping SourceColumn="Middle_NM" DataSetColumn="Middle_NM" />
              <Mapping SourceColumn="Other_NM" DataSetColumn="Other_NM" />
              <Mapping SourceColumn="MRID" DataSetColumn="MRID" />
              <Mapping SourceColumn="Birth_Place" DataSetColumn="Birth_Place" />
              <Mapping SourceColumn="Marital_Status_ID" DataSetColumn="Marital_Status_ID" />
              <Mapping SourceColumn="Language_ID" DataSetColumn="Language_ID" />
              <Mapping SourceColumn="Religion_ID" DataSetColumn="Religion_ID" />
              <Mapping SourceColumn="Age" DataSetColumn="Age" />
              <Mapping SourceColumn="Emer_RelationShip" DataSetColumn="Emer_RelationShip" />
              <Mapping SourceColumn="Emer_Last_NM" DataSetColumn="Emer_Last_NM" />
              <Mapping SourceColumn="Emer_1stNM" DataSetColumn="Emer_1stNM" />
              <Mapping SourceColumn="Emer_Addr1" DataSetColumn="Emer_Addr1" />
              <Mapping SourceColumn="Emer_Addr2" DataSetColumn="Emer_Addr2" />
              <Mapping SourceColumn="Emer_City" DataSetColumn="Emer_City" />
              <Mapping SourceColumn="Emer_Postal" DataSetColumn="Emer_Postal" />
              <Mapping SourceColumn="Emer_Phone" DataSetColumn="Emer_Phone" />
              <Mapping SourceColumn="Emer_Fax" DataSetColumn="Emer_Fax" />
              <Mapping SourceColumn="Emer_State" DataSetColumn="Emer_State" />
              <Mapping SourceColumn="Emer_Country" DataSetColumn="Emer_Country" />
              <Mapping SourceColumn="Emer_CellPhone" DataSetColumn="Emer_CellPhone" />
              <Mapping SourceColumn="Emer_Email" DataSetColumn="Emer_Email" />
              <Mapping SourceColumn="Reserved_1" DataSetColumn="Reserved_1" />
              <Mapping SourceColumn="Reserved_2" DataSetColumn="Reserved_2" />
              <Mapping SourceColumn="Reserved_3" DataSetColumn="Reserved_3" />
              <Mapping SourceColumn="Reserved_4" DataSetColumn="Reserved_4" />
              <Mapping SourceColumn="Reserved_5" DataSetColumn="Reserved_5" />
              <Mapping SourceColumn="Reserved_6" DataSetColumn="Reserved_6" />
              <Mapping SourceColumn="Reserved_7" DataSetColumn="Reserved_7" />
              <Mapping SourceColumn="Reserved_8" DataSetColumn="Reserved_8" />
              <Mapping SourceColumn="Prim_Physician" DataSetColumn="Prim_Physician" />
              <Mapping SourceColumn="Ref1_Physician" DataSetColumn="Ref1_Physician" />
              <Mapping SourceColumn="Ref2_Physician" DataSetColumn="Ref2_Physician" />
              <Mapping SourceColumn="Ref1_Addr1" DataSetColumn="Ref1_Addr1" />
              <Mapping SourceColumn="Ref1_Phone" DataSetColumn="Ref1_Phone" />
              <Mapping SourceColumn="Ref1_Fax" DataSetColumn="Ref1_Fax" />
              <Mapping SourceColumn="Ref1_Email" DataSetColumn="Ref1_Email" />
              <Mapping SourceColumn="Ref1_Facility" DataSetColumn="Ref1_Facility" />
              <Mapping SourceColumn="Ref2_Addr1" DataSetColumn="Ref2_Addr1" />
              <Mapping SourceColumn="Ref2_Phone" DataSetColumn="Ref2_Phone" />
              <Mapping SourceColumn="Ref2_Fax" DataSetColumn="Ref2_Fax" />
              <Mapping SourceColumn="Ref2_Email" DataSetColumn="Ref2_Email" />
              <Mapping SourceColumn="Ref2_Facility" DataSetColumn="Ref2_Facility" />
              <Mapping SourceColumn="Salutation_ID" DataSetColumn="Salutation_ID" />
              <Mapping SourceColumn="Register_Dt" DataSetColumn="Register_Dt" />
              <Mapping SourceColumn="W_Addr1" DataSetColumn="W_Addr1" />
              <Mapping SourceColumn="W_Addr2" DataSetColumn="W_Addr2" />
              <Mapping SourceColumn="W_City" DataSetColumn="W_City" />
              <Mapping SourceColumn="W_Postal" DataSetColumn="W_Postal" />
              <Mapping SourceColumn="W_Phone" DataSetColumn="W_Phone" />
              <Mapping SourceColumn="W_Fax" DataSetColumn="W_Fax" />
              <Mapping SourceColumn="W_State" DataSetColumn="W_State" />
              <Mapping SourceColumn="W_Country" DataSetColumn="W_Country" />
              <Mapping SourceColumn="W_CellPhone" DataSetColumn="W_CellPhone" />
              <Mapping SourceColumn="W_Email" DataSetColumn="W_Email" />
              <Mapping SourceColumn="Al_Addr1" DataSetColumn="Al_Addr1" />
              <Mapping SourceColumn="Al_Addr2" DataSetColumn="Al_Addr2" />
              <Mapping SourceColumn="Al_City" DataSetColumn="Al_City" />
              <Mapping SourceColumn="Al_Postal" DataSetColumn="Al_Postal" />
              <Mapping SourceColumn="Al_Phone" DataSetColumn="Al_Phone" />
              <Mapping SourceColumn="Al_Fax" DataSetColumn="Al_Fax" />
              <Mapping SourceColumn="Al_State" DataSetColumn="Al_State" />
              <Mapping SourceColumn="Al_Country" DataSetColumn="Al_Country" />
              <Mapping SourceColumn="AL_CellPhone" DataSetColumn="AL_CellPhone" />
              <Mapping SourceColumn="AL_Email" DataSetColumn="AL_Email" />
              <Mapping SourceColumn="Patient_No" DataSetColumn="Patient_No" />
              <Mapping SourceColumn="Create_Dt" DataSetColumn="Create_Dt" />
              <Mapping SourceColumn="TimeStamps" DataSetColumn="TimeStamps" />
              <Mapping SourceColumn="Create_UserId" DataSetColumn="Create_UserId" />
              <Mapping SourceColumn="Edit_UserId" DataSetColumn="Edit_UserId" />
              <Mapping SourceColumn="NRIC" DataSetColumn="NRIC" />
              <Mapping SourceColumn="Status" DataSetColumn="Status" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="SettingTableAdapter" GeneratorDataComponentClassName="SettingTableAdapter" Name="Setting" UserDataComponentName="SettingTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="B2BConnectionString (MySettings)" DbObjectName="B2B.dbo.Setting" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetData" UserSourceName="Fill">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>INSERT INTO [dbo].[Setting] ([Setting_ID], [Setting_Description], [Setting_Value]) VALUES (@Setting_ID, @Setting_Description, @Setting_Value)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Setting_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Setting_ID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Setting_Description" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Setting_Description" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Setting_Value" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Setting_Value" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>SELECT Setting_ID, Setting_Description, Setting_Value FROM dbo.Setting</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Setting_ID" DataSetColumn="Setting_ID" />
              <Mapping SourceColumn="Setting_Description" DataSetColumn="Setting_Description" />
              <Mapping SourceColumn="Setting_Value" DataSetColumn="Setting_Value" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="UsersTableAdapter" GeneratorDataComponentClassName="UsersTableAdapter" Name="Users" UserDataComponentName="UsersTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="B2BConnectionString (MySettings)" DbObjectName="B2B.dbo.Users" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetData" UserSourceName="Fill">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>INSERT INTO [dbo].[Users] ([User_Login], [User_Name], [User_Password], [Sec_View], [Sec_Modify], [Sec_Delete], [Sec_Print]) VALUES (@User_Login, @User_Name, @User_Password, @Sec_View, @Sec_Modify, @Sec_Delete, @Sec_Print)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@User_Login" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="User_Login" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@User_Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="User_Name" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@User_Password" Precision="0" ProviderType="Binary" Scale="0" Size="0" SourceColumn="User_Password" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Sec_View" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Sec_View" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Sec_Modify" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Sec_Modify" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Sec_Delete" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Sec_Delete" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Sec_Print" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Sec_Print" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>SELECT User_ID1, User_Login, User_Name, User_Password, Sec_View, Sec_Modify, Sec_Delete, Sec_Print FROM dbo.Users</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="User_ID1" DataSetColumn="User_ID1" />
              <Mapping SourceColumn="User_Login" DataSetColumn="User_Login" />
              <Mapping SourceColumn="User_Name" DataSetColumn="User_Name" />
              <Mapping SourceColumn="User_Password" DataSetColumn="User_Password" />
              <Mapping SourceColumn="Sec_View" DataSetColumn="Sec_View" />
              <Mapping SourceColumn="Sec_Modify" DataSetColumn="Sec_Modify" />
              <Mapping SourceColumn="Sec_Delete" DataSetColumn="Sec_Delete" />
              <Mapping SourceColumn="Sec_Print" DataSetColumn="Sec_Print" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
        </Tables>
        <Sources>
        </Sources>
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="B2BDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_UserDSName="B2BDataSet" msprop:Generator_DataSetName="B2BDataSet">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="EXT_PATIENT" msprop:Generator_UserTableName="EXT_PATIENT" msprop:Generator_RowDeletedName="EXT_PATIENTRowDeleted" msprop:Generator_TableClassName="EXT_PATIENTDataTable" msprop:Generator_RowChangedName="EXT_PATIENTRowChanged" msprop:Generator_RowClassName="EXT_PATIENTRow" msprop:Generator_RowChangingName="EXT_PATIENTRowChanging" msprop:Generator_RowEvArgName="EXT_PATIENTRowChangeEvent" msprop:Generator_RowEvHandlerName="EXT_PATIENTRowChangeEventHandler" msprop:Generator_TablePropName="EXT_PATIENT" msprop:Generator_TableVarName="tableEXT_PATIENT" msprop:Generator_RowDeletingName="EXT_PATIENTRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="PTNT_PRN" msprop:Generator_UserColumnName="PTNT_PRN" msprop:Generator_ColumnPropNameInRow="PTNT_PRN" msprop:Generator_ColumnVarNameInTable="columnPTNT_PRN" msprop:Generator_ColumnPropNameInTable="PTNT_PRNColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PRSN_BIRTH_DATE" msprop:Generator_UserColumnName="PRSN_BIRTH_DATE" msprop:Generator_ColumnPropNameInRow="PRSN_BIRTH_DATE" msprop:Generator_ColumnVarNameInTable="columnPRSN_BIRTH_DATE" msprop:Generator_ColumnPropNameInTable="PRSN_BIRTH_DATEColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="PDTL_RACE" msprop:Generator_UserColumnName="PDTL_RACE" msprop:Generator_ColumnPropNameInRow="PDTL_RACE" msprop:Generator_ColumnVarNameInTable="columnPDTL_RACE" msprop:Generator_ColumnPropNameInTable="PDTL_RACEColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PRSN_SEX" msprop:Generator_UserColumnName="PRSN_SEX" msprop:Generator_ColumnPropNameInRow="PRSN_SEX" msprop:Generator_ColumnVarNameInTable="columnPRSN_SEX" msprop:Generator_ColumnPropNameInTable="PRSN_SEXColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PRSN_SURNAME" msprop:Generator_UserColumnName="PRSN_SURNAME" msprop:Generator_ColumnPropNameInRow="PRSN_SURNAME" msprop:Generator_ColumnVarNameInTable="columnPRSN_SURNAME" msprop:Generator_ColumnPropNameInTable="PRSN_SURNAMEColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="80" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PDTL_NATIONALITY" msprop:Generator_UserColumnName="PDTL_NATIONALITY" msprop:Generator_ColumnPropNameInRow="PDTL_NATIONALITY" msprop:Generator_ColumnVarNameInTable="columnPDTL_NATIONALITY" msprop:Generator_ColumnPropNameInTable="PDTL_NATIONALITYColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Nationality" msprop:Generator_UserTableName="Nationality" msprop:Generator_RowDeletedName="NationalityRowDeleted" msprop:Generator_TableClassName="NationalityDataTable" msprop:Generator_RowChangedName="NationalityRowChanged" msprop:Generator_RowClassName="NationalityRow" msprop:Generator_RowChangingName="NationalityRowChanging" msprop:Generator_RowEvArgName="NationalityRowChangeEvent" msprop:Generator_RowEvHandlerName="NationalityRowChangeEventHandler" msprop:Generator_TablePropName="Nationality" msprop:Generator_TableVarName="tableNationality" msprop:Generator_RowDeletingName="NationalityRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Code" msprop:Generator_UserColumnName="Code" msprop:Generator_ColumnPropNameInRow="Code" msprop:Generator_ColumnVarNameInTable="columnCode" msprop:Generator_ColumnPropNameInTable="CodeColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Description" msprop:Generator_UserColumnName="Description" msprop:Generator_ColumnPropNameInRow="Description" msprop:Generator_ColumnVarNameInTable="columnDescription" msprop:Generator_ColumnPropNameInTable="DescriptionColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Patient" msprop:Generator_UserTableName="Patient" msprop:Generator_RowDeletedName="PatientRowDeleted" msprop:Generator_TableClassName="PatientDataTable" msprop:Generator_RowChangedName="PatientRowChanged" msprop:Generator_RowClassName="PatientRow" msprop:Generator_RowChangingName="PatientRowChanging" msprop:Generator_RowEvArgName="PatientRowChangeEvent" msprop:Generator_RowEvHandlerName="PatientRowChangeEventHandler" msprop:Generator_TablePropName="Patient" msprop:Generator_TableVarName="tablePatient" msprop:Generator_RowDeletingName="PatientRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Patient_Id" msprop:Generator_UserColumnName="Patient_Id" msprop:Generator_ColumnPropNameInRow="Patient_Id" msprop:Generator_ColumnVarNameInTable="columnPatient_Id" msprop:Generator_ColumnPropNameInTable="Patient_IdColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="patient_NM" msprop:Generator_UserColumnName="patient_NM" msprop:Generator_ColumnPropNameInRow="patient_NM" msprop:Generator_ColumnVarNameInTable="columnpatient_NM" msprop:Generator_ColumnPropNameInTable="patient_NMColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DOB" msprop:Generator_UserColumnName="DOB" msprop:Generator_ColumnPropNameInRow="DOB" msprop:Generator_ColumnVarNameInTable="columnDOB" msprop:Generator_ColumnPropNameInTable="DOBColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="Gender" msprop:Generator_UserColumnName="Gender" msprop:Generator_ColumnPropNameInRow="Gender" msprop:Generator_ColumnVarNameInTable="columnGender" msprop:Generator_ColumnPropNameInTable="GenderColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Addr1" msprop:Generator_UserColumnName="Addr1" msprop:Generator_ColumnPropNameInRow="Addr1" msprop:Generator_ColumnVarNameInTable="columnAddr1" msprop:Generator_ColumnPropNameInTable="Addr1Column" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Addr2" msprop:Generator_UserColumnName="Addr2" msprop:Generator_ColumnPropNameInRow="Addr2" msprop:Generator_ColumnVarNameInTable="columnAddr2" msprop:Generator_ColumnPropNameInTable="Addr2Column" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Addr3" msprop:Generator_UserColumnName="Addr3" msprop:Generator_ColumnPropNameInRow="Addr3" msprop:Generator_ColumnVarNameInTable="columnAddr3" msprop:Generator_ColumnPropNameInTable="Addr3Column" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="City" msprop:Generator_UserColumnName="City" msprop:Generator_ColumnPropNameInRow="City" msprop:Generator_ColumnVarNameInTable="columnCity" msprop:Generator_ColumnPropNameInTable="CityColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Postal" msprop:Generator_UserColumnName="Postal" msprop:Generator_ColumnPropNameInRow="Postal" msprop:Generator_ColumnVarNameInTable="columnPostal" msprop:Generator_ColumnPropNameInTable="PostalColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Phone" msprop:Generator_UserColumnName="Phone" msprop:Generator_ColumnPropNameInRow="Phone" msprop:Generator_ColumnVarNameInTable="columnPhone" msprop:Generator_ColumnPropNameInTable="PhoneColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Fax" msprop:Generator_UserColumnName="Fax" msprop:Generator_ColumnPropNameInRow="Fax" msprop:Generator_ColumnVarNameInTable="columnFax" msprop:Generator_ColumnPropNameInTable="FaxColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="State" msprop:Generator_UserColumnName="State" msprop:Generator_ColumnPropNameInRow="State" msprop:Generator_ColumnVarNameInTable="columnState" msprop:Generator_ColumnPropNameInTable="StateColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Country" msprop:Generator_UserColumnName="Country" msprop:Generator_ColumnPropNameInRow="Country" msprop:Generator_ColumnVarNameInTable="columnCountry" msprop:Generator_ColumnPropNameInTable="CountryColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CellPhone" msprop:Generator_UserColumnName="CellPhone" msprop:Generator_ColumnPropNameInRow="CellPhone" msprop:Generator_ColumnVarNameInTable="columnCellPhone" msprop:Generator_ColumnPropNameInTable="CellPhoneColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Email" msprop:Generator_UserColumnName="Email" msprop:Generator_ColumnPropNameInRow="Email" msprop:Generator_ColumnVarNameInTable="columnEmail" msprop:Generator_ColumnPropNameInTable="EmailColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="M_Addr1" msprop:Generator_UserColumnName="M_Addr1" msprop:Generator_ColumnPropNameInRow="M_Addr1" msprop:Generator_ColumnVarNameInTable="columnM_Addr1" msprop:Generator_ColumnPropNameInTable="M_Addr1Column" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="M_Addr2" msprop:Generator_UserColumnName="M_Addr2" msprop:Generator_ColumnPropNameInRow="M_Addr2" msprop:Generator_ColumnVarNameInTable="columnM_Addr2" msprop:Generator_ColumnPropNameInTable="M_Addr2Column" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="M_Addr3" msprop:Generator_UserColumnName="M_Addr3" msprop:Generator_ColumnPropNameInRow="M_Addr3" msprop:Generator_ColumnVarNameInTable="columnM_Addr3" msprop:Generator_ColumnPropNameInTable="M_Addr3Column" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="M_City" msprop:Generator_UserColumnName="M_City" msprop:Generator_ColumnPropNameInRow="M_City" msprop:Generator_ColumnVarNameInTable="columnM_City" msprop:Generator_ColumnPropNameInTable="M_CityColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="M_Postal" msprop:Generator_UserColumnName="M_Postal" msprop:Generator_ColumnPropNameInRow="M_Postal" msprop:Generator_ColumnVarNameInTable="columnM_Postal" msprop:Generator_ColumnPropNameInTable="M_PostalColumn" type="xs:int" minOccurs="0" />
              <xs:element name="M_Phone" msprop:Generator_UserColumnName="M_Phone" msprop:Generator_ColumnPropNameInRow="M_Phone" msprop:Generator_ColumnVarNameInTable="columnM_Phone" msprop:Generator_ColumnPropNameInTable="M_PhoneColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="M_Fax" msprop:Generator_UserColumnName="M_Fax" msprop:Generator_ColumnPropNameInRow="M_Fax" msprop:Generator_ColumnVarNameInTable="columnM_Fax" msprop:Generator_ColumnPropNameInTable="M_FaxColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="M_State" msprop:Generator_UserColumnName="M_State" msprop:Generator_ColumnPropNameInRow="M_State" msprop:Generator_ColumnVarNameInTable="columnM_State" msprop:Generator_ColumnPropNameInTable="M_StateColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="M_country" msprop:Generator_UserColumnName="M_country" msprop:Generator_ColumnPropNameInRow="M_country" msprop:Generator_ColumnVarNameInTable="columnM_country" msprop:Generator_ColumnPropNameInTable="M_countryColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="M_CellPhone" msprop:Generator_UserColumnName="M_CellPhone" msprop:Generator_ColumnPropNameInRow="M_CellPhone" msprop:Generator_ColumnVarNameInTable="columnM_CellPhone" msprop:Generator_ColumnPropNameInTable="M_CellPhoneColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="M_Email" msprop:Generator_UserColumnName="M_Email" msprop:Generator_ColumnPropNameInRow="M_Email" msprop:Generator_ColumnVarNameInTable="columnM_Email" msprop:Generator_ColumnPropNameInTable="M_EmailColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Last_NM" msprop:Generator_UserColumnName="Last_NM" msprop:Generator_ColumnPropNameInRow="Last_NM" msprop:Generator_ColumnVarNameInTable="columnLast_NM" msprop:Generator_ColumnPropNameInTable="Last_NMColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="First_NM" msprop:Generator_UserColumnName="First_NM" msprop:Generator_ColumnPropNameInRow="First_NM" msprop:Generator_ColumnVarNameInTable="columnFirst_NM" msprop:Generator_ColumnPropNameInTable="First_NMColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Middle_NM" msprop:Generator_UserColumnName="Middle_NM" msprop:Generator_ColumnPropNameInRow="Middle_NM" msprop:Generator_ColumnVarNameInTable="columnMiddle_NM" msprop:Generator_ColumnPropNameInTable="Middle_NMColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Other_NM" msprop:Generator_UserColumnName="Other_NM" msprop:Generator_ColumnPropNameInRow="Other_NM" msprop:Generator_ColumnVarNameInTable="columnOther_NM" msprop:Generator_ColumnPropNameInTable="Other_NMColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="MRID" msprop:Generator_UserColumnName="MRID" msprop:Generator_ColumnPropNameInRow="MRID" msprop:Generator_ColumnVarNameInTable="columnMRID" msprop:Generator_ColumnPropNameInTable="MRIDColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Birth_Place" msprop:Generator_UserColumnName="Birth_Place" msprop:Generator_ColumnPropNameInRow="Birth_Place" msprop:Generator_ColumnVarNameInTable="columnBirth_Place" msprop:Generator_ColumnPropNameInTable="Birth_PlaceColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Marital_Status_ID" msprop:Generator_UserColumnName="Marital_Status_ID" msprop:Generator_ColumnPropNameInRow="Marital_Status_ID" msprop:Generator_ColumnVarNameInTable="columnMarital_Status_ID" msprop:Generator_ColumnPropNameInTable="Marital_Status_IDColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Language_ID" msprop:Generator_UserColumnName="Language_ID" msprop:Generator_ColumnPropNameInRow="Language_ID" msprop:Generator_ColumnVarNameInTable="columnLanguage_ID" msprop:Generator_ColumnPropNameInTable="Language_IDColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Religion_ID" msprop:Generator_UserColumnName="Religion_ID" msprop:Generator_ColumnPropNameInRow="Religion_ID" msprop:Generator_ColumnVarNameInTable="columnReligion_ID" msprop:Generator_ColumnPropNameInTable="Religion_IDColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Age" msprop:Generator_UserColumnName="Age" msprop:Generator_ColumnPropNameInRow="Age" msprop:Generator_ColumnVarNameInTable="columnAge" msprop:Generator_ColumnPropNameInTable="AgeColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Emer_RelationShip" msprop:Generator_UserColumnName="Emer_RelationShip" msprop:Generator_ColumnPropNameInRow="Emer_RelationShip" msprop:Generator_ColumnVarNameInTable="columnEmer_RelationShip" msprop:Generator_ColumnPropNameInTable="Emer_RelationShipColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Emer_Last_NM" msprop:Generator_UserColumnName="Emer_Last_NM" msprop:Generator_ColumnPropNameInRow="Emer_Last_NM" msprop:Generator_ColumnVarNameInTable="columnEmer_Last_NM" msprop:Generator_ColumnPropNameInTable="Emer_Last_NMColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Emer_1stNM" msprop:Generator_UserColumnName="Emer_1stNM" msprop:Generator_ColumnPropNameInRow="Emer_1stNM" msprop:Generator_ColumnVarNameInTable="columnEmer_1stNM" msprop:Generator_ColumnPropNameInTable="Emer_1stNMColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Emer_Addr1" msprop:Generator_UserColumnName="Emer_Addr1" msprop:Generator_ColumnPropNameInRow="Emer_Addr1" msprop:Generator_ColumnVarNameInTable="columnEmer_Addr1" msprop:Generator_ColumnPropNameInTable="Emer_Addr1Column" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Emer_Addr2" msprop:Generator_UserColumnName="Emer_Addr2" msprop:Generator_ColumnPropNameInRow="Emer_Addr2" msprop:Generator_ColumnVarNameInTable="columnEmer_Addr2" msprop:Generator_ColumnPropNameInTable="Emer_Addr2Column" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Emer_City" msprop:Generator_UserColumnName="Emer_City" msprop:Generator_ColumnPropNameInRow="Emer_City" msprop:Generator_ColumnVarNameInTable="columnEmer_City" msprop:Generator_ColumnPropNameInTable="Emer_CityColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Emer_Postal" msprop:Generator_UserColumnName="Emer_Postal" msprop:Generator_ColumnPropNameInRow="Emer_Postal" msprop:Generator_ColumnVarNameInTable="columnEmer_Postal" msprop:Generator_ColumnPropNameInTable="Emer_PostalColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Emer_Phone" msprop:Generator_UserColumnName="Emer_Phone" msprop:Generator_ColumnPropNameInRow="Emer_Phone" msprop:Generator_ColumnVarNameInTable="columnEmer_Phone" msprop:Generator_ColumnPropNameInTable="Emer_PhoneColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Emer_Fax" msprop:Generator_UserColumnName="Emer_Fax" msprop:Generator_ColumnPropNameInRow="Emer_Fax" msprop:Generator_ColumnVarNameInTable="columnEmer_Fax" msprop:Generator_ColumnPropNameInTable="Emer_FaxColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Emer_State" msprop:Generator_UserColumnName="Emer_State" msprop:Generator_ColumnPropNameInRow="Emer_State" msprop:Generator_ColumnVarNameInTable="columnEmer_State" msprop:Generator_ColumnPropNameInTable="Emer_StateColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Emer_Country" msprop:Generator_UserColumnName="Emer_Country" msprop:Generator_ColumnPropNameInRow="Emer_Country" msprop:Generator_ColumnVarNameInTable="columnEmer_Country" msprop:Generator_ColumnPropNameInTable="Emer_CountryColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Emer_CellPhone" msprop:Generator_UserColumnName="Emer_CellPhone" msprop:Generator_ColumnPropNameInRow="Emer_CellPhone" msprop:Generator_ColumnVarNameInTable="columnEmer_CellPhone" msprop:Generator_ColumnPropNameInTable="Emer_CellPhoneColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Emer_Email" msprop:Generator_UserColumnName="Emer_Email" msprop:Generator_ColumnPropNameInRow="Emer_Email" msprop:Generator_ColumnVarNameInTable="columnEmer_Email" msprop:Generator_ColumnPropNameInTable="Emer_EmailColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Reserved_1" msprop:Generator_UserColumnName="Reserved_1" msprop:Generator_ColumnPropNameInRow="Reserved_1" msprop:Generator_ColumnVarNameInTable="columnReserved_1" msprop:Generator_ColumnPropNameInTable="Reserved_1Column" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Reserved_2" msprop:Generator_UserColumnName="Reserved_2" msprop:Generator_ColumnPropNameInRow="Reserved_2" msprop:Generator_ColumnVarNameInTable="columnReserved_2" msprop:Generator_ColumnPropNameInTable="Reserved_2Column" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Reserved_3" msprop:Generator_UserColumnName="Reserved_3" msprop:Generator_ColumnPropNameInRow="Reserved_3" msprop:Generator_ColumnVarNameInTable="columnReserved_3" msprop:Generator_ColumnPropNameInTable="Reserved_3Column" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Reserved_4" msprop:Generator_UserColumnName="Reserved_4" msprop:Generator_ColumnPropNameInRow="Reserved_4" msprop:Generator_ColumnVarNameInTable="columnReserved_4" msprop:Generator_ColumnPropNameInTable="Reserved_4Column" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Reserved_5" msprop:Generator_UserColumnName="Reserved_5" msprop:Generator_ColumnPropNameInRow="Reserved_5" msprop:Generator_ColumnVarNameInTable="columnReserved_5" msprop:Generator_ColumnPropNameInTable="Reserved_5Column" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Reserved_6" msprop:Generator_UserColumnName="Reserved_6" msprop:Generator_ColumnPropNameInRow="Reserved_6" msprop:Generator_ColumnVarNameInTable="columnReserved_6" msprop:Generator_ColumnPropNameInTable="Reserved_6Column" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Reserved_7" msprop:Generator_UserColumnName="Reserved_7" msprop:Generator_ColumnPropNameInRow="Reserved_7" msprop:Generator_ColumnVarNameInTable="columnReserved_7" msprop:Generator_ColumnPropNameInTable="Reserved_7Column" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Reserved_8" msprop:Generator_UserColumnName="Reserved_8" msprop:Generator_ColumnPropNameInRow="Reserved_8" msprop:Generator_ColumnVarNameInTable="columnReserved_8" msprop:Generator_ColumnPropNameInTable="Reserved_8Column" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Prim_Physician" msprop:Generator_UserColumnName="Prim_Physician" msprop:Generator_ColumnPropNameInRow="Prim_Physician" msprop:Generator_ColumnVarNameInTable="columnPrim_Physician" msprop:Generator_ColumnPropNameInTable="Prim_PhysicianColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Ref1_Physician" msprop:Generator_UserColumnName="Ref1_Physician" msprop:Generator_ColumnPropNameInRow="Ref1_Physician" msprop:Generator_ColumnVarNameInTable="columnRef1_Physician" msprop:Generator_ColumnPropNameInTable="Ref1_PhysicianColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Ref2_Physician" msprop:Generator_UserColumnName="Ref2_Physician" msprop:Generator_ColumnPropNameInRow="Ref2_Physician" msprop:Generator_ColumnVarNameInTable="columnRef2_Physician" msprop:Generator_ColumnPropNameInTable="Ref2_PhysicianColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Ref1_Addr1" msprop:Generator_UserColumnName="Ref1_Addr1" msprop:Generator_ColumnPropNameInRow="Ref1_Addr1" msprop:Generator_ColumnVarNameInTable="columnRef1_Addr1" msprop:Generator_ColumnPropNameInTable="Ref1_Addr1Column" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Ref1_Phone" msprop:Generator_UserColumnName="Ref1_Phone" msprop:Generator_ColumnPropNameInRow="Ref1_Phone" msprop:Generator_ColumnVarNameInTable="columnRef1_Phone" msprop:Generator_ColumnPropNameInTable="Ref1_PhoneColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Ref1_Fax" msprop:Generator_UserColumnName="Ref1_Fax" msprop:Generator_ColumnPropNameInRow="Ref1_Fax" msprop:Generator_ColumnVarNameInTable="columnRef1_Fax" msprop:Generator_ColumnPropNameInTable="Ref1_FaxColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Ref1_Email" msprop:Generator_UserColumnName="Ref1_Email" msprop:Generator_ColumnPropNameInRow="Ref1_Email" msprop:Generator_ColumnVarNameInTable="columnRef1_Email" msprop:Generator_ColumnPropNameInTable="Ref1_EmailColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Ref1_Facility" msprop:Generator_UserColumnName="Ref1_Facility" msprop:Generator_ColumnPropNameInRow="Ref1_Facility" msprop:Generator_ColumnVarNameInTable="columnRef1_Facility" msprop:Generator_ColumnPropNameInTable="Ref1_FacilityColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Ref2_Addr1" msprop:Generator_UserColumnName="Ref2_Addr1" msprop:Generator_ColumnPropNameInRow="Ref2_Addr1" msprop:Generator_ColumnVarNameInTable="columnRef2_Addr1" msprop:Generator_ColumnPropNameInTable="Ref2_Addr1Column" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Ref2_Phone" msprop:Generator_UserColumnName="Ref2_Phone" msprop:Generator_ColumnPropNameInRow="Ref2_Phone" msprop:Generator_ColumnVarNameInTable="columnRef2_Phone" msprop:Generator_ColumnPropNameInTable="Ref2_PhoneColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Ref2_Fax" msprop:Generator_UserColumnName="Ref2_Fax" msprop:Generator_ColumnPropNameInRow="Ref2_Fax" msprop:Generator_ColumnVarNameInTable="columnRef2_Fax" msprop:Generator_ColumnPropNameInTable="Ref2_FaxColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Ref2_Email" msprop:Generator_UserColumnName="Ref2_Email" msprop:Generator_ColumnPropNameInRow="Ref2_Email" msprop:Generator_ColumnVarNameInTable="columnRef2_Email" msprop:Generator_ColumnPropNameInTable="Ref2_EmailColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Ref2_Facility" msprop:Generator_UserColumnName="Ref2_Facility" msprop:Generator_ColumnPropNameInRow="Ref2_Facility" msprop:Generator_ColumnVarNameInTable="columnRef2_Facility" msprop:Generator_ColumnPropNameInTable="Ref2_FacilityColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Salutation_ID" msprop:Generator_UserColumnName="Salutation_ID" msprop:Generator_ColumnPropNameInRow="Salutation_ID" msprop:Generator_ColumnVarNameInTable="columnSalutation_ID" msprop:Generator_ColumnPropNameInTable="Salutation_IDColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Register_Dt" msprop:Generator_UserColumnName="Register_Dt" msprop:Generator_ColumnPropNameInRow="Register_Dt" msprop:Generator_ColumnVarNameInTable="columnRegister_Dt" msprop:Generator_ColumnPropNameInTable="Register_DtColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="W_Addr1" msprop:Generator_UserColumnName="W_Addr1" msprop:Generator_ColumnPropNameInRow="W_Addr1" msprop:Generator_ColumnVarNameInTable="columnW_Addr1" msprop:Generator_ColumnPropNameInTable="W_Addr1Column" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="W_Addr2" msprop:Generator_UserColumnName="W_Addr2" msprop:Generator_ColumnPropNameInRow="W_Addr2" msprop:Generator_ColumnVarNameInTable="columnW_Addr2" msprop:Generator_ColumnPropNameInTable="W_Addr2Column" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="W_City" msprop:Generator_UserColumnName="W_City" msprop:Generator_ColumnPropNameInRow="W_City" msprop:Generator_ColumnVarNameInTable="columnW_City" msprop:Generator_ColumnPropNameInTable="W_CityColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="W_Postal" msprop:Generator_UserColumnName="W_Postal" msprop:Generator_ColumnPropNameInRow="W_Postal" msprop:Generator_ColumnVarNameInTable="columnW_Postal" msprop:Generator_ColumnPropNameInTable="W_PostalColumn" type="xs:int" minOccurs="0" />
              <xs:element name="W_Phone" msprop:Generator_UserColumnName="W_Phone" msprop:Generator_ColumnPropNameInRow="W_Phone" msprop:Generator_ColumnVarNameInTable="columnW_Phone" msprop:Generator_ColumnPropNameInTable="W_PhoneColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="W_Fax" msprop:Generator_UserColumnName="W_Fax" msprop:Generator_ColumnPropNameInRow="W_Fax" msprop:Generator_ColumnVarNameInTable="columnW_Fax" msprop:Generator_ColumnPropNameInTable="W_FaxColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="W_State" msprop:Generator_UserColumnName="W_State" msprop:Generator_ColumnPropNameInRow="W_State" msprop:Generator_ColumnVarNameInTable="columnW_State" msprop:Generator_ColumnPropNameInTable="W_StateColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="W_Country" msprop:Generator_UserColumnName="W_Country" msprop:Generator_ColumnPropNameInRow="W_Country" msprop:Generator_ColumnVarNameInTable="columnW_Country" msprop:Generator_ColumnPropNameInTable="W_CountryColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="W_CellPhone" msprop:Generator_UserColumnName="W_CellPhone" msprop:Generator_ColumnPropNameInRow="W_CellPhone" msprop:Generator_ColumnVarNameInTable="columnW_CellPhone" msprop:Generator_ColumnPropNameInTable="W_CellPhoneColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="W_Email" msprop:Generator_UserColumnName="W_Email" msprop:Generator_ColumnPropNameInRow="W_Email" msprop:Generator_ColumnVarNameInTable="columnW_Email" msprop:Generator_ColumnPropNameInTable="W_EmailColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Al_Addr1" msprop:Generator_UserColumnName="Al_Addr1" msprop:Generator_ColumnPropNameInRow="Al_Addr1" msprop:Generator_ColumnVarNameInTable="columnAl_Addr1" msprop:Generator_ColumnPropNameInTable="Al_Addr1Column" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Al_Addr2" msprop:Generator_UserColumnName="Al_Addr2" msprop:Generator_ColumnPropNameInRow="Al_Addr2" msprop:Generator_ColumnVarNameInTable="columnAl_Addr2" msprop:Generator_ColumnPropNameInTable="Al_Addr2Column" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Al_City" msprop:Generator_UserColumnName="Al_City" msprop:Generator_ColumnPropNameInRow="Al_City" msprop:Generator_ColumnVarNameInTable="columnAl_City" msprop:Generator_ColumnPropNameInTable="Al_CityColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Al_Postal" msprop:Generator_UserColumnName="Al_Postal" msprop:Generator_ColumnPropNameInRow="Al_Postal" msprop:Generator_ColumnVarNameInTable="columnAl_Postal" msprop:Generator_ColumnPropNameInTable="Al_PostalColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Al_Phone" msprop:Generator_UserColumnName="Al_Phone" msprop:Generator_ColumnPropNameInRow="Al_Phone" msprop:Generator_ColumnVarNameInTable="columnAl_Phone" msprop:Generator_ColumnPropNameInTable="Al_PhoneColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Al_Fax" msprop:Generator_UserColumnName="Al_Fax" msprop:Generator_ColumnPropNameInRow="Al_Fax" msprop:Generator_ColumnVarNameInTable="columnAl_Fax" msprop:Generator_ColumnPropNameInTable="Al_FaxColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Al_State" msprop:Generator_UserColumnName="Al_State" msprop:Generator_ColumnPropNameInRow="Al_State" msprop:Generator_ColumnVarNameInTable="columnAl_State" msprop:Generator_ColumnPropNameInTable="Al_StateColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Al_Country" msprop:Generator_UserColumnName="Al_Country" msprop:Generator_ColumnPropNameInRow="Al_Country" msprop:Generator_ColumnVarNameInTable="columnAl_Country" msprop:Generator_ColumnPropNameInTable="Al_CountryColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="AL_CellPhone" msprop:Generator_UserColumnName="AL_CellPhone" msprop:Generator_ColumnPropNameInRow="AL_CellPhone" msprop:Generator_ColumnVarNameInTable="columnAL_CellPhone" msprop:Generator_ColumnPropNameInTable="AL_CellPhoneColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="AL_Email" msprop:Generator_UserColumnName="AL_Email" msprop:Generator_ColumnPropNameInRow="AL_Email" msprop:Generator_ColumnVarNameInTable="columnAL_Email" msprop:Generator_ColumnPropNameInTable="AL_EmailColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Patient_No" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="Patient_No" msprop:Generator_ColumnPropNameInRow="Patient_No" msprop:Generator_ColumnVarNameInTable="columnPatient_No" msprop:Generator_ColumnPropNameInTable="Patient_NoColumn" type="xs:int" />
              <xs:element name="Create_Dt" msprop:Generator_UserColumnName="Create_Dt" msprop:Generator_ColumnPropNameInRow="Create_Dt" msprop:Generator_ColumnVarNameInTable="columnCreate_Dt" msprop:Generator_ColumnPropNameInTable="Create_DtColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="TimeStamps" msprop:Generator_UserColumnName="TimeStamps" msprop:Generator_ColumnPropNameInRow="TimeStamps" msprop:Generator_ColumnVarNameInTable="columnTimeStamps" msprop:Generator_ColumnPropNameInTable="TimeStampsColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="Create_UserId" msprop:Generator_UserColumnName="Create_UserId" msprop:Generator_ColumnPropNameInRow="Create_UserId" msprop:Generator_ColumnVarNameInTable="columnCreate_UserId" msprop:Generator_ColumnPropNameInTable="Create_UserIdColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Edit_UserId" msprop:Generator_UserColumnName="Edit_UserId" msprop:Generator_ColumnPropNameInRow="Edit_UserId" msprop:Generator_ColumnVarNameInTable="columnEdit_UserId" msprop:Generator_ColumnPropNameInTable="Edit_UserIdColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="NRIC" msprop:Generator_UserColumnName="NRIC" msprop:Generator_ColumnPropNameInRow="NRIC" msprop:Generator_ColumnVarNameInTable="columnNRIC" msprop:Generator_ColumnPropNameInTable="NRICColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Status" msprop:Generator_UserColumnName="Status" msprop:Generator_ColumnPropNameInRow="Status" msprop:Generator_ColumnVarNameInTable="columnStatus" msprop:Generator_ColumnPropNameInTable="StatusColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Setting" msprop:Generator_UserTableName="Setting" msprop:Generator_RowDeletedName="SettingRowDeleted" msprop:Generator_TableClassName="SettingDataTable" msprop:Generator_RowChangedName="SettingRowChanged" msprop:Generator_RowClassName="SettingRow" msprop:Generator_RowChangingName="SettingRowChanging" msprop:Generator_RowEvArgName="SettingRowChangeEvent" msprop:Generator_RowEvHandlerName="SettingRowChangeEventHandler" msprop:Generator_TablePropName="Setting" msprop:Generator_TableVarName="tableSetting" msprop:Generator_RowDeletingName="SettingRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Setting_ID" msprop:Generator_UserColumnName="Setting_ID" msprop:Generator_ColumnPropNameInRow="Setting_ID" msprop:Generator_ColumnVarNameInTable="columnSetting_ID" msprop:Generator_ColumnPropNameInTable="Setting_IDColumn" type="xs:int" />
              <xs:element name="Setting_Description" msprop:Generator_UserColumnName="Setting_Description" msprop:Generator_ColumnPropNameInRow="Setting_Description" msprop:Generator_ColumnVarNameInTable="columnSetting_Description" msprop:Generator_ColumnPropNameInTable="Setting_DescriptionColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Setting_Value" msprop:Generator_UserColumnName="Setting_Value" msprop:Generator_ColumnPropNameInRow="Setting_Value" msprop:Generator_ColumnVarNameInTable="columnSetting_Value" msprop:Generator_ColumnPropNameInTable="Setting_ValueColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Users" msprop:Generator_UserTableName="Users" msprop:Generator_RowDeletedName="UsersRowDeleted" msprop:Generator_TableClassName="UsersDataTable" msprop:Generator_RowChangedName="UsersRowChanged" msprop:Generator_RowClassName="UsersRow" msprop:Generator_RowChangingName="UsersRowChanging" msprop:Generator_RowEvArgName="UsersRowChangeEvent" msprop:Generator_RowEvHandlerName="UsersRowChangeEventHandler" msprop:Generator_TablePropName="Users" msprop:Generator_TableVarName="tableUsers" msprop:Generator_RowDeletingName="UsersRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="User_ID1" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="User_ID1" msprop:Generator_ColumnPropNameInRow="User_ID1" msprop:Generator_ColumnVarNameInTable="columnUser_ID1" msprop:Generator_ColumnPropNameInTable="User_ID1Column" type="xs:int" />
              <xs:element name="User_Login" msprop:Generator_UserColumnName="User_Login" msprop:Generator_ColumnPropNameInRow="User_Login" msprop:Generator_ColumnVarNameInTable="columnUser_Login" msprop:Generator_ColumnPropNameInTable="User_LoginColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="User_Name" msprop:Generator_UserColumnName="User_Name" msprop:Generator_ColumnPropNameInRow="User_Name" msprop:Generator_ColumnVarNameInTable="columnUser_Name" msprop:Generator_ColumnPropNameInTable="User_NameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="User_Password" msprop:Generator_UserColumnName="User_Password" msprop:Generator_ColumnPropNameInRow="User_Password" msprop:Generator_ColumnVarNameInTable="columnUser_Password" msprop:Generator_ColumnPropNameInTable="User_PasswordColumn" type="xs:base64Binary" minOccurs="0" />
              <xs:element name="Sec_View" msprop:Generator_UserColumnName="Sec_View" msprop:Generator_ColumnPropNameInRow="Sec_View" msprop:Generator_ColumnVarNameInTable="columnSec_View" msprop:Generator_ColumnPropNameInTable="Sec_ViewColumn" type="xs:boolean" minOccurs="0" />
              <xs:element name="Sec_Modify" msprop:Generator_UserColumnName="Sec_Modify" msprop:Generator_ColumnPropNameInRow="Sec_Modify" msprop:Generator_ColumnVarNameInTable="columnSec_Modify" msprop:Generator_ColumnPropNameInTable="Sec_ModifyColumn" type="xs:boolean" minOccurs="0" />
              <xs:element name="Sec_Delete" msprop:Generator_UserColumnName="Sec_Delete" msprop:Generator_ColumnPropNameInRow="Sec_Delete" msprop:Generator_ColumnVarNameInTable="columnSec_Delete" msprop:Generator_ColumnPropNameInTable="Sec_DeleteColumn" type="xs:boolean" minOccurs="0" />
              <xs:element name="Sec_Print" msprop:Generator_UserColumnName="Sec_Print" msprop:Generator_ColumnPropNameInRow="Sec_Print" msprop:Generator_ColumnVarNameInTable="columnSec_Print" msprop:Generator_ColumnPropNameInTable="Sec_PrintColumn" type="xs:boolean" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
  </xs:element>
</xs:schema>